<html>
	<head>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
		<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico" />
		
		<title>Contact Broker Details</title>
		<style type="text/css" media="screen">
			@import "css/site_jui.ccss.css";
			@import "css/demo_table_jui.css";
			@import "css/jquery-ui-1.7.2.custom.css";
			
			.dataTables_info { padding-top: 0; }
			.dataTables_paginate { padding-top: 0; }
			.css_right { float: right; }
			#example_wrapper .fg-toolbar { font-size: 0.8em }
			#theme_links span { float: left; padding: 2px 10px; }
			#example_wrapper { -webkit-box-shadow: 2px 2px 6px #666; box-shadow: 2px 2px 6px #666; border-radius: 5px; }
			#example tbody {
				border-left: 1px solid #AAA;
				border-right: 1px solid #AAA;
			}
			#example thead th:first-child { border-left: 1px solid #AAA; }
			#example thead th:last-child { border-right: 1px solid #AAA; }
		</style>
		
		<script type="text/javascript" src="js/complete.js"></script>
		<script type="text/javascript" src="js/jquery.dataTables.min.js"></script>
		<script type="text/javascript">
			function fnFeaturesInit ()
			{
				/* Not particularly modular this - but does nicely :-) */
				$('ul.limit_length>li').each( function(i) {
					if ( i > 10 ) {
						this.style.display = 'none';
					}
				} );
				
				$('ul.limit_length').append( '<li class="css_link">Show more<\/li>' );
				$('ul.limit_length li.css_link').click( function () {
					$('ul.limit_length li').each( function(i) {
						if ( i > 25 ) {
							this.style.display = 'list-item';
						}
					} );
					$('ul.limit_length li.css_link').css( 'display', 'none' );
				} );
			}
			
			$(document).ready( function() {

				fnFeaturesInit();
				$('#example').dataTable( {
					"bJQueryUI": true,
					"sPaginationType": "full_numbers"
				} );
				
				SyntaxHighlighter.config.clipboardSwf = 'js/clipboard.swf';
				SyntaxHighlighter.all();
			} );
		</script>
	</head>

	<body id="dt_example">
		<div id="container">
			<div id="demo">
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">


<?php
include '../php/db.php'; 

$rs_result=getContactDetails();

?>

	<thead>
		<tr>
			<th>Name</th>
			<th>Title</th>
			<th>Company</th>
			<th>Email</th>
			<th>Role</th>
			<th>Create Date</th>
			<th>Active Leases</th>
			<th>Private Leases</th>
		</tr>

	</thead>
<tbody>
<?php 
while ($row = mysql_fetch_assoc($rs_result)) { 
?> 
<tr>
   <td><?php echo $row["name"]; ?></td>
   <td><?php echo $row["title"]; ?></td>
   <td><?php echo $row["company"]; ?></td>
   <td><?php echo $row["email"]; ?></td>
   <td><?php echo $row["role"]; ?></td>
   <td><?php echo $row["cdate"]; ?></td>
   <td><?php echo $row["active"]; ?></td>
   <td><?php echo $row["pvlease"]; ?></td>
</tr>
<?php 
}; 
?> 
</tbody>
</table>
</div>
</div>
</body>
</html>



